<%-- 
    Document   : md_graph
    Created on : 2009-6-12, 18:40:55
    Author     : Administrator
--%>

<%@page language="java" contentType="text/html; charset=UTF-8" %>
<%@page import="btsm.bean.sqlwork,btsm.bean.BTSPage,java.sql.*"%>
<%!ResultSet rs;%>
<%String titlename="蓄电池";%>
<script language="javascript" src="jscheck.js">
</script>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
    <TITLE><%=titlename%>查询</TITLE><!--更改-->
    <META http-equiv=Content-Type content="text/html; charset=UTF-8">
    <LINK href="Admin_Style.css" type=text/css rel=stylesheet>
	
    <script>
    <%
        BTSPage mypage = new BTSPage("storagebattery", "1");//更改
		
		String strbsSign = request.getParameter("bsSign");
		String strFilter = request.getParameter("txtFilter");
		String strUTF8Filter = "";
		if(strFilter == null || strFilter.equals("null"))
			strFilter = "";
		else
			strUTF8Filter = new String(strFilter.getBytes("ISO8859-1"), "UTF-8");			
	%>
    </script>
</HEAD>
<BODY leftMargin="2" topMargin="0" marginheight="0" marginwidth="0" style="overflow:hidden">
<script>
    <!--
    function tst(obj0,obj1,obj2){
        obj0.style.border="1 "+obj1+" solid";
        obj0.style.background=obj2;
    }
    //-->
</script>
<SCRIPT>
    function tjsjx(x){
        document.hj_myform.sjidxid.value=x;
        document.hj_myform.sjidxg.value="xg";
        hj_myform.submit();
    }
</SCRIPT>
<script>
function genQuery(){
	frmQuery.bsSign.value = "1";
    frmQuery.submit();
}
</script>

<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>

<!--*********搜索工具条开始*****************-->		
<FORM name="frmQuery" action="list_sbattery.jsp" method="post">

            <TR class=tdbg onMouseOver="this.className='tdbgmouseover'" onMouseOut="this.className='tdbg'" align=middle>
                <TD width="1157" colspan="13">
                    <p><input type="hidden" name="bsSign" value="0">  查  询： <input type="text" name="txtFilter" size="20" style="width: 159; height: 20" class=text2d onBlur="checkQuote(this.value,this)" onKeyDown="if(event.keyCode==13){genQuery()};" value="<%=strUTF8Filter%>">&nbsp;&nbsp;&nbsp;
                        <input type="button" value=" 搜索 " name="btnQuery" style="width: 40; height: 20" class=tx_button onClick="genQuery()" onMouseOver="tst(this,'blue','#ffffff')" onMouseOut="tst(this,'black','#e8e7fe')">
                   &nbsp;&nbsp;&nbsp;<input type="checkbox" title="模糊匹配" checked="checked"　name="chkBlur">模糊匹配 
                   </p>
                </TD>
            </TR>
</FORM>

<!--*********搜索工具条结束*****************-->	

<TR>
<TD>
    <TABLE class=border cellSpacing=1 cellPadding=2 width="100%" align=center border=0><!--表宽度不能变百分之百-->
        <FORM name="hj_myform" action="ser_sbattery" method="post"><!--更改-->
            <TBODY id=Tabs>
            <!--表管理列表表头开始-->
            <TR class=title align=middle height=2l2>
                <TD>流水号</TD>
                <TD>基站编号</TD>
                <TD>基站名称</TD>
                <TD>规格型号</TD>
                <TD>厂家</TD>
                <TD>容量</TD>
                <TD>启用日期</TD>
                <TD>放电时长</TD>
                <TD><p align="center">更换及维修记录</p></TD>
                <TD>数据更新时间</TD>
            </TR>

            <!--表管理列表表头结束-->
  <!--表管理记录开始-->
<%
		
        if (strbsSign == null || strbsSign.equals("0") || strFilter == null || strFilter.equals("")) {
            rs = mypage.myQuery(request, response, 1, 10);
        } else {
            rs = mypage.BlurQuery(request, response,1, 10, strFilter);
        }
		
        while (rs.next()) {
            %>
            <TR class=tdbg onMouseOver="this.className='tdbgmouseover'" onMouseOut="this.className='tdbg'" align=middle>
                <TD><%=rs.getString(1)%></TD>
                <TD><%=rs.getString(2)%></TD>
                <TD><%=rs.getString(3)%></TD>
                <TD><%=rs.getString(4)%></TD>
                <TD><%=rs.getString(5)%></TD>
                <TD><%=rs.getString(6)%></TD>
                <TD><%=rs.getString(10)%></TD>
                <TD><%=rs.getString(11)%></TD>
                <TD><%=rs.getString(12)%></TD>
                <TD><%=rs.getDate(13)%></TD>
            </TR>
            <!--表管理记录结束-->
       <%
        }
		String footer;
        if (strbsSign == null || strbsSign.equals("0") || strFilter == null || strFilter.equals(""))
			footer = mypage.PageFooter("list_sbattery.jsp?txtFilter="+strFilter+"&");
		else
			footer = mypage.PageFooter("list_sbattery.jsp?txtFilter="+strFilter+"&bsSign=" + strbsSign + "&");		
       %>
       <% 
       		rs.close();
		    mypage.dbConClose();
       %>

            <TR class=tdbg onMouseOver="this.className='tdbgmouseover'" onMouseOut="this.className='tdbg'" align=middle>
            <TD width="1157" colspan="13">
            <p align="left">
                                    <%
            String jspName = request.getRequestURI();
            jspName = jspName.substring(jspName.lastIndexOf("/") + 1);
                                    %>

                      <input type="hidden" name="filesnames" value=<%=jspName%>>

        </FORM>
        </p>
    </TD>
    </TR>
    <TR class=tdbg onMouseOver="this.className='tdbgmouseover'" onMouseOut="this.className='tdbg'" align=middle>
        <TD width="1157" colspan="13">
            <p align="center">
            <div class="article-bottom">
                <div class="pages">
                    <%out.println(footer);%>
                </div>
            </div><!--article-bottom -->
          <!--content -->
            <!--mainWrapper -->
            <div id="footer">
                <div id="innerFooter"></div>
            </div>

        </TD>
    </TR>
    </TBODY>
</TABLE>
</TD></TR></TBODY></TABLE>
</BODY></HTML>